import { Op } from 'sequelize'
import { sequelize } from '../../../modules/BaseDao'

class EvaluateDao {
  static EvaluateDao: EvaluateDao = new EvaluateDao()
  // 获取评论和回复列表   要对数据进行  convert
  findEvalReplyLst( fisbn: string): Promise<[any, any]> {
    const sql = `SELECT * FROM evaluate e left outer join dangdang.reply r
    on e.evaluateid=r.evalid where e.isbn='${fisbn}'`;
    return sequelize.query(sql);
  }

}

export default EvaluateDao.EvaluateDao
